﻿CREATE PROCEDURE [dbo].[GetPublishersForAuthor]
	@authorId int
AS
	select	pv.*
	from	PublisherAuthor as pa
	inner   join PublisherView as pv on pv.PublisherId = pa.PublisherId
	where	pa.AuthorId = @authorId
	order   by pv.PublisherName;
RETURN 0